﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

public partial class AddSpecialRecharge : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        string packageName = txtpackageName.Text;
        string duration = txtDuration.Text;
        string denominations = txtDenominations.Text;
        string discount = txtDiscount.Text;
        string description = txtDescription.Text;

        SqlConnection con = new SqlConnection("server=KIENNT-PC\\SQLEXPRESS;database=OnlineMobileRecharge;uid=sa;pwd=123456");
        SqlCommand cmd = new SqlCommand("insert into SpecialRecharge(_packageName,_durationDate,_discount,_denominations,_description) values('" + packageName + "','" + duration + "','" + denominations + "','" + discount + "','" + description + "')", con);
        con.Open();
        cmd.ExecuteNonQuery();
        con.Close();
    }
}